package br.com.integrator.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class ConnectionFactory {
    
    public static Connection getConnection() throws Exception{
        try{
            
                        
             
            Class.forName("oracle.jdbc.driver.OracleDriver");

              return DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "hr", "hr");
             
           
           
           
            
        }catch (Exception e){
            throw new Exception(e.getMessage());
        }
    }
    
    public static void closeConnection(Connection conn,
            Statement stmt, ResultSet rs) throws Exception{
        close(conn, stmt, rs);
    }
    
    public static void closeConnection(Connection conn, Statement stmt)
            throws Exception {
        close(conn, stmt, null);
    }
    
    public static void closeConnection(Connection conn)
            throws Exception{
        close(conn, null, null);
    }
    
    private static void close(Connection conn, Statement stmt, ResultSet rs)
            throws Exception{
        try{
            if(rs != null) rs.close();
            if(stmt != null) stmt.close();
            if(conn != null) conn.close();
        }catch (Exception e){
            throw new Exception(e.getMessage());
        }
    }
}
